﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="IPAMSDataSet" targetNamespace="http://tempuri.org/IPAMSDataSet.xsd" xmlns:mstns="http://tempuri.org/IPAMSDataSet.xsd" xmlns="http://tempuri.org/IPAMSDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="IPAMSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="IPAMSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.IPAMS.Properties.Settings.GlobalReference.Default.IPAMSConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ActionTableAdapter" GeneratorDataComponentClassName="ActionTableAdapter" Name="Action" UserDataComponentName="ActionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Action" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Action] WHERE (([ID] = @Original_ID) AND ([Description] = @Original_Description))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Action] ([ID], [Description]) VALUES (@ID, @Description);
SELECT ID, Description FROM Action WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Description FROM dbo.Action</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Action] SET [ID] = @ID, [Description] = @Description WHERE (([ID] = @Original_ID) AND ([Description] = @Original_Description));
SELECT ID, Description FROM Action WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaxTableAdapter" GeneratorDataComponentClassName="TaxTableAdapter" Name="Tax" UserDataComponentName="TaxTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Tax" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Tax] WHERE (([ID] = @Original_ID) AND ([PackageID] = @Original_PackageID) AND ([ActionId] = @Original_ActionId) AND ([Name] = @Original_Name) AND ([CountryCode] = @Original_CountryCode) AND ((@IsNull_Rate = 1 AND [Rate] IS NULL) OR ([Rate] = @Original_Rate)) AND ([ValidFromDate] = @Original_ValidFromDate) AND ([ValidToDate] = @Original_ValidToDate) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ActionId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFromDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidFromDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidToDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidToDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tax] ([ID], [PackageID], [ActionId], [Name], [CountryCode], [Rate], [ValidFromDate], [ValidToDate], [TransactionID]) VALUES (@ID, @PackageID, @ActionId, @Name, @CountryCode, @Rate, @ValidFromDate, @ValidToDate, @TransactionID);
SELECT ID, PackageID, ActionId, Name, CountryCode, Rate, ValidFromDate, ValidToDate, TransactionID FROM Tax WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ActionId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFromDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidFromDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidToDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidToDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, PackageID, ActionId, Name, CountryCode, Rate, ValidFromDate, ValidToDate, TransactionID FROM dbo.Tax</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tax] SET [ID] = @ID, [PackageID] = @PackageID, [ActionId] = @ActionId, [Name] = @Name, [CountryCode] = @CountryCode, [Rate] = @Rate, [ValidFromDate] = @ValidFromDate, [ValidToDate] = @ValidToDate, [TransactionID] = @TransactionID WHERE (([ID] = @Original_ID) AND ([PackageID] = @Original_PackageID) AND ([ActionId] = @Original_ActionId) AND ([Name] = @Original_Name) AND ([CountryCode] = @Original_CountryCode) AND ((@IsNull_Rate = 1 AND [Rate] IS NULL) OR ([Rate] = @Original_Rate)) AND ([ValidFromDate] = @Original_ValidFromDate) AND ([ValidToDate] = @Original_ValidToDate) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)));
SELECT ID, PackageID, ActionId, Name, CountryCode, Rate, ValidFromDate, ValidToDate, TransactionID FROM Tax WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ActionId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFromDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidFromDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidToDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidToDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ActionId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFromDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidFromDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidToDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidToDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="PackageID" DataSetColumn="PackageID" />
              <Mapping SourceColumn="ActionId" DataSetColumn="ActionId" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
              <Mapping SourceColumn="Rate" DataSetColumn="Rate" />
              <Mapping SourceColumn="ValidFromDate" DataSetColumn="ValidFromDate" />
              <Mapping SourceColumn="ValidToDate" DataSetColumn="ValidToDate" />
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CashActionTableAdapter" GeneratorDataComponentClassName="CashActionTableAdapter" Name="CashAction" UserDataComponentName="CashActionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.CashAction" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CashAction] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CashAction] ([ID], [Name]) VALUES (@ID, @Name);
SELECT ID, Name FROM CashAction WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name FROM dbo.CashAction</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CashAction] SET [ID] = @ID, [Name] = @Name WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name));
SELECT ID, Name FROM CashAction WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CashPortfolioTableAdapter" GeneratorDataComponentClassName="CashPortfolioTableAdapter" Name="CashPortfolio" UserDataComponentName="CashPortfolioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.CashPortfolio" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CashPortfolio] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CashPortfolio] ([ID], [Name]) VALUES (@ID, @Name);
SELECT ID, Name FROM CashPortfolio WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name FROM dbo.CashPortfolio</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CashPortfolio] SET [ID] = @ID, [Name] = @Name WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name));
SELECT ID, Name FROM CashPortfolio WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CashTransactionTableAdapter" GeneratorDataComponentClassName="CashTransactionTableAdapter" Name="CashTransaction" UserDataComponentName="CashTransactionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.CashTransaction" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CashTransaction] WHERE (([CashPotfolioID] = @Original_CashPotfolioID) AND ([TransactionID] = @Original_TransactionID) AND ([ActionID] = @Original_ActionID) AND ([Amount] = @Original_Amount) AND ([CurrencyCode] = @Original_CurrencyCode) AND ([DateTime] = @Original_DateTime))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CashPotfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CashPotfolioID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Amount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateTime" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CashTransaction] ([CashPotfolioID], [TransactionID], [ActionID], [Amount], [CurrencyCode], [DateTime]) VALUES (@CashPotfolioID, @TransactionID, @ActionID, @Amount, @CurrencyCode, @DateTime);
SELECT CashPotfolioID, TransactionID, ActionID, Amount, CurrencyCode, DateTime FROM CashTransaction WHERE (TransactionID = @TransactionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CashPotfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CashPotfolioID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Amount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateTime" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CashPotfolioID, TransactionID, ActionID, Amount, CurrencyCode, DateTime FROM dbo.CashTransaction</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CashTransaction] SET [CashPotfolioID] = @CashPotfolioID, [TransactionID] = @TransactionID, [ActionID] = @ActionID, [Amount] = @Amount, [CurrencyCode] = @CurrencyCode, [DateTime] = @DateTime WHERE (([CashPotfolioID] = @Original_CashPotfolioID) AND ([TransactionID] = @Original_TransactionID) AND ([ActionID] = @Original_ActionID) AND ([Amount] = @Original_Amount) AND ([CurrencyCode] = @Original_CurrencyCode) AND ([DateTime] = @Original_DateTime));
SELECT CashPotfolioID, TransactionID, ActionID, Amount, CurrencyCode, DateTime FROM CashTransaction WHERE (TransactionID = @TransactionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CashPotfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CashPotfolioID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Amount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateTime" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CashPotfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CashPotfolioID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Amount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateTime" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CashPotfolioID" DataSetColumn="CashPotfolioID" />
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
              <Mapping SourceColumn="ActionID" DataSetColumn="ActionID" />
              <Mapping SourceColumn="Amount" DataSetColumn="Amount" />
              <Mapping SourceColumn="CurrencyCode" DataSetColumn="CurrencyCode" />
              <Mapping SourceColumn="DateTime" DataSetColumn="DateTime" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CommissionTableAdapter" GeneratorDataComponentClassName="CommissionTableAdapter" Name="Commission" UserDataComponentName="CommissionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Commission" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Commission] WHERE (([ID] = @Original_ID) AND ([SourceID] = @Original_SourceID) AND ([InvestmentHouseID] = @Original_InvestmentHouseID) AND ([Name] = @Original_Name) AND ((@IsNull_ActionID = 1 AND [ActionID] IS NULL) OR ([ActionID] = @Original_ActionID)) AND ([CurrencyCode] = @Original_CurrencyCode) AND ((@IsNull_Min = 1 AND [Min] IS NULL) OR ([Min] = @Original_Min)) AND ((@IsNull_Max = 1 AND [Max] IS NULL) OR ([Max] = @Original_Max)) AND ((@IsNull_Rate = 1 AND [Rate] IS NULL) OR ([Rate] = @Original_Rate)) AND ((@IsNull_PeriodMonths = 1 AND [PeriodMonths] IS NULL) OR ([PeriodMonths] = @Original_PeriodMonths)) AND ((@IsNull_PerOneStock = 1 AND [PerOneStock] IS NULL) OR ([PerOneStock] = @Original_PerOneStock)) AND ([ValidFromDate] = @Original_ValidFromDate) AND ([ValidToDate] = @Original_ValidToDate) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_InvestmentHouseID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="InvestmentHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ActionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Min" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Min" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Min" Precision="16" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Min" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Max" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Max" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Max" Precision="16" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Max" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PeriodMonths" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodMonths" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PeriodMonths" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodMonths" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PerOneStock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PerOneStock" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PerOneStock" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="PerOneStock" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFromDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidFromDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidToDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidToDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Commission] ([ID], [SourceID], [InvestmentHouseID], [Name], [ActionID], [CurrencyCode], [Min], [Max], [Rate], [PeriodMonths], [PerOneStock], [ValidFromDate], [ValidToDate], [TransactionID]) VALUES (@ID, @SourceID, @InvestmentHouseID, @Name, @ActionID, @CurrencyCode, @Min, @Max, @Rate, @PeriodMonths, @PerOneStock, @ValidFromDate, @ValidToDate, @TransactionID);
SELECT ID, SourceID, InvestmentHouseID, Name, ActionID, CurrencyCode, Min, Max, Rate, PeriodMonths, PerOneStock, ValidFromDate, ValidToDate, TransactionID FROM Commission WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@InvestmentHouseID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="InvestmentHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Min" Precision="16" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Min" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Max" Precision="16" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Max" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PeriodMonths" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodMonths" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PerOneStock" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="PerOneStock" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFromDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidFromDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidToDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidToDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, SourceID, InvestmentHouseID, Name, ActionID, CurrencyCode, Min, Max, Rate, PeriodMonths, PerOneStock, ValidFromDate, ValidToDate, TransactionID FROM dbo.Commission</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Commission] SET [ID] = @ID, [SourceID] = @SourceID, [InvestmentHouseID] = @InvestmentHouseID, [Name] = @Name, [ActionID] = @ActionID, [CurrencyCode] = @CurrencyCode, [Min] = @Min, [Max] = @Max, [Rate] = @Rate, [PeriodMonths] = @PeriodMonths, [PerOneStock] = @PerOneStock, [ValidFromDate] = @ValidFromDate, [ValidToDate] = @ValidToDate, [TransactionID] = @TransactionID WHERE (([ID] = @Original_ID) AND ([SourceID] = @Original_SourceID) AND ([InvestmentHouseID] = @Original_InvestmentHouseID) AND ([Name] = @Original_Name) AND ((@IsNull_ActionID = 1 AND [ActionID] IS NULL) OR ([ActionID] = @Original_ActionID)) AND ([CurrencyCode] = @Original_CurrencyCode) AND ((@IsNull_Min = 1 AND [Min] IS NULL) OR ([Min] = @Original_Min)) AND ((@IsNull_Max = 1 AND [Max] IS NULL) OR ([Max] = @Original_Max)) AND ((@IsNull_Rate = 1 AND [Rate] IS NULL) OR ([Rate] = @Original_Rate)) AND ((@IsNull_PeriodMonths = 1 AND [PeriodMonths] IS NULL) OR ([PeriodMonths] = @Original_PeriodMonths)) AND ((@IsNull_PerOneStock = 1 AND [PerOneStock] IS NULL) OR ([PerOneStock] = @Original_PerOneStock)) AND ([ValidFromDate] = @Original_ValidFromDate) AND ([ValidToDate] = @Original_ValidToDate) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)));
SELECT ID, SourceID, InvestmentHouseID, Name, ActionID, CurrencyCode, Min, Max, Rate, PeriodMonths, PerOneStock, ValidFromDate, ValidToDate, TransactionID FROM Commission WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@InvestmentHouseID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="InvestmentHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Min" Precision="16" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Min" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Max" Precision="16" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Max" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PeriodMonths" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodMonths" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PerOneStock" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="PerOneStock" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFromDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidFromDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidToDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidToDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_InvestmentHouseID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="InvestmentHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ActionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Min" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Min" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Min" Precision="16" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Min" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Max" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Max" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Max" Precision="16" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Max" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PeriodMonths" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodMonths" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PeriodMonths" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodMonths" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PerOneStock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PerOneStock" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PerOneStock" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="PerOneStock" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFromDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidFromDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidToDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValidToDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="SourceID" DataSetColumn="SourceID" />
              <Mapping SourceColumn="InvestmentHouseID" DataSetColumn="InvestmentHouseID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ActionID" DataSetColumn="ActionID" />
              <Mapping SourceColumn="CurrencyCode" DataSetColumn="CurrencyCode" />
              <Mapping SourceColumn="Min" DataSetColumn="Min" />
              <Mapping SourceColumn="Max" DataSetColumn="Max" />
              <Mapping SourceColumn="Rate" DataSetColumn="Rate" />
              <Mapping SourceColumn="PeriodMonths" DataSetColumn="PeriodMonths" />
              <Mapping SourceColumn="PerOneStock" DataSetColumn="PerOneStock" />
              <Mapping SourceColumn="ValidFromDate" DataSetColumn="ValidFromDate" />
              <Mapping SourceColumn="ValidToDate" DataSetColumn="ValidToDate" />
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CountryTableAdapter" GeneratorDataComponentClassName="CountryTableAdapter" Name="Country" UserDataComponentName="CountryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Country" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Country] WHERE (([Code] = @Original_Code) AND ([Name] = @Original_Name) AND ([CurrencyCode] = @Original_CurrencyCode))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Country] ([Code], [Name], [CurrencyCode]) VALUES (@Code, @Name, @CurrencyCode);
SELECT Code, Name, CurrencyCode FROM Country WHERE (Code = @Code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code, Name, CurrencyCode FROM dbo.Country</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Country] SET [Code] = @Code, [Name] = @Name, [CurrencyCode] = @CurrencyCode WHERE (([Code] = @Original_Code) AND ([Name] = @Original_Name) AND ([CurrencyCode] = @Original_CurrencyCode));
SELECT Code, Name, CurrencyCode FROM Country WHERE (Code = @Code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="CurrencyCode" DataSetColumn="CurrencyCode" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CurrencyTableAdapter" GeneratorDataComponentClassName="CurrencyTableAdapter" Name="Currency" UserDataComponentName="CurrencyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Currency" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Currency] WHERE (([Code] = @Original_Code) AND ([Name] = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Currency] ([Code], [Name]) VALUES (@Code, @Name);
SELECT Code, Name FROM Currency WHERE (Code = @Code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code, Name FROM dbo.Currency</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Currency] SET [Code] = @Code, [Name] = @Name WHERE (([Code] = @Original_Code) AND ([Name] = @Original_Name));
SELECT Code, Name FROM Currency WHERE (Code = @Code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DividendsQuoteTableAdapter" GeneratorDataComponentClassName="DividendsQuoteTableAdapter" Name="DividendsQuote" UserDataComponentName="DividendsQuoteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.DividendsQuote" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DividendsQuote] WHERE (([PaperID] = @Original_PaperID) AND ([ExDate] = @Original_ExDate) AND ([Value] = @Original_Value) AND ([PackageID] = @Original_PackageID) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ExDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ExDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Value" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Value" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DividendsQuote] ([PaperID], [ExDate], [Value], [PackageID], [TransactionID]) VALUES (@PaperID, @ExDate, @Value, @PackageID, @TransactionID);
SELECT PaperID, ExDate, Value, PackageID, TransactionID FROM DividendsQuote WHERE (ExDate = @ExDate) AND (PackageID = @PackageID) AND (PaperID = @PaperID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ExDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Value" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Value" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PaperID, ExDate, Value, PackageID, TransactionID FROM dbo.DividendsQuote</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DividendsQuote] SET [PaperID] = @PaperID, [ExDate] = @ExDate, [Value] = @Value, [PackageID] = @PackageID, [TransactionID] = @TransactionID WHERE (([PaperID] = @Original_PaperID) AND ([ExDate] = @Original_ExDate) AND ([Value] = @Original_Value) AND ([PackageID] = @Original_PackageID) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)));
SELECT PaperID, ExDate, Value, PackageID, TransactionID FROM DividendsQuote WHERE (ExDate = @ExDate) AND (PackageID = @PackageID) AND (PaperID = @PaperID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ExDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Value" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Value" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ExDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ExDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Value" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Value" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PaperID" DataSetColumn="PaperID" />
              <Mapping SourceColumn="ExDate" DataSetColumn="ExDate" />
              <Mapping SourceColumn="Value" DataSetColumn="Value" />
              <Mapping SourceColumn="PackageID" DataSetColumn="PackageID" />
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ExchangeRatesQuoteTableAdapter" GeneratorDataComponentClassName="ExchangeRatesQuoteTableAdapter" Name="ExchangeRatesQuote" UserDataComponentName="ExchangeRatesQuoteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.ExchangeRatesQuote" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ExchangeRatesQuote] WHERE (([SourceCurrencyCode] = @Original_SourceCurrencyCode) AND ([TargetCurrencyCode] = @Original_TargetCurrencyCode) AND ([Date] = @Original_Date) AND ([Rate] = @Original_Rate) AND ([PackageID] = @Original_PackageID) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SourceCurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceCurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TargetCurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TargetCurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ExchangeRatesQuote] ([SourceCurrencyCode], [TargetCurrencyCode], [Date], [Rate], [PackageID], [TransactionID]) VALUES (@SourceCurrencyCode, @TargetCurrencyCode, @Date, @Rate, @PackageID, @TransactionID);
SELECT SourceCurrencyCode, TargetCurrencyCode, Date, Rate, PackageID, TransactionID FROM ExchangeRatesQuote WHERE (Date = @Date) AND (PackageID = @PackageID) AND (SourceCurrencyCode = @SourceCurrencyCode) AND (TargetCurrencyCode = @TargetCurrencyCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SourceCurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceCurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TargetCurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TargetCurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SourceCurrencyCode, TargetCurrencyCode, Date, Rate, PackageID, TransactionID FROM dbo.ExchangeRatesQuote</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ExchangeRatesQuote] SET [SourceCurrencyCode] = @SourceCurrencyCode, [TargetCurrencyCode] = @TargetCurrencyCode, [Date] = @Date, [Rate] = @Rate, [PackageID] = @PackageID, [TransactionID] = @TransactionID WHERE (([SourceCurrencyCode] = @Original_SourceCurrencyCode) AND ([TargetCurrencyCode] = @Original_TargetCurrencyCode) AND ([Date] = @Original_Date) AND ([Rate] = @Original_Rate) AND ([PackageID] = @Original_PackageID) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)));
SELECT SourceCurrencyCode, TargetCurrencyCode, Date, Rate, PackageID, TransactionID FROM ExchangeRatesQuote WHERE (Date = @Date) AND (PackageID = @PackageID) AND (SourceCurrencyCode = @SourceCurrencyCode) AND (TargetCurrencyCode = @TargetCurrencyCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SourceCurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceCurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TargetCurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TargetCurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SourceCurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceCurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TargetCurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TargetCurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Rate" Precision="8" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="Rate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SourceCurrencyCode" DataSetColumn="SourceCurrencyCode" />
              <Mapping SourceColumn="TargetCurrencyCode" DataSetColumn="TargetCurrencyCode" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
              <Mapping SourceColumn="Rate" DataSetColumn="Rate" />
              <Mapping SourceColumn="PackageID" DataSetColumn="PackageID" />
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InvestmentHouseTableAdapter" GeneratorDataComponentClassName="InvestmentHouseTableAdapter" Name="InvestmentHouse" UserDataComponentName="InvestmentHouseTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.InvestmentHouse" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[InvestmentHouse] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_URL = 1 AND [URL] IS NULL) OR ([URL] = @Original_URL)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[InvestmentHouse] ([ID], [Name], [URL]) VALUES (@ID, @Name, @URL);
SELECT ID, Name, URL FROM InvestmentHouse WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, URL FROM dbo.InvestmentHouse</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[InvestmentHouse] SET [ID] = @ID, [Name] = @Name, [URL] = @URL WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_URL = 1 AND [URL] IS NULL) OR ([URL] = @Original_URL)));
SELECT ID, Name, URL FROM InvestmentHouse WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="URL" DataSetColumn="URL" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ManagerTableAdapter" GeneratorDataComponentClassName="ManagerTableAdapter" Name="Manager" UserDataComponentName="ManagerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Manager" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Manager] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([MobilePhone] = @Original_MobilePhone))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_MobilePhone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Manager] ([ID], [Name], [MobilePhone]) VALUES (@ID, @Name, @MobilePhone);
SELECT ID, Name, MobilePhone FROM Manager WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@MobilePhone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, MobilePhone FROM dbo.Manager</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Manager] SET [ID] = @ID, [Name] = @Name, [MobilePhone] = @MobilePhone WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([MobilePhone] = @Original_MobilePhone));
SELECT ID, Name, MobilePhone FROM Manager WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@MobilePhone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_MobilePhone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="MobilePhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="MobilePhone" DataSetColumn="MobilePhone" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PackageTableAdapter" GeneratorDataComponentClassName="PackageTableAdapter" Name="Package" UserDataComponentName="PackageTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Package" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Package] WHERE (([ID] = @Original_ID) AND ([SourceID] = @Original_SourceID) AND ([Type] = @Original_Type) AND ([DateTime] = @Original_DateTime))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateTime" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Package] ([ID], [SourceID], [Type], [DateTime]) VALUES (@ID, @SourceID, @Type, @DateTime);
SELECT ID, SourceID, Type, DateTime FROM Package WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateTime" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, SourceID, Type, DateTime FROM dbo.Package</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Package] SET [ID] = @ID, [SourceID] = @SourceID, [Type] = @Type, [DateTime] = @DateTime WHERE (([ID] = @Original_ID) AND ([SourceID] = @Original_SourceID) AND ([Type] = @Original_Type) AND ([DateTime] = @Original_DateTime));
SELECT ID, SourceID, Type, DateTime FROM Package WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateTime" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateTime" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DateTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="SourceID" DataSetColumn="SourceID" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="DateTime" DataSetColumn="DateTime" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PaperTableAdapter" GeneratorDataComponentClassName="PaperTableAdapter" Name="Paper" UserDataComponentName="PaperTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Paper" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Paper] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([Type] = @Original_Type) AND ([Symbol] = @Original_Symbol) AND ((@IsNull_StockExchangeCode = 1 AND [StockExchangeCode] IS NULL) OR ([StockExchangeCode] = @Original_StockExchangeCode)) AND ((@IsNull_CountryCode = 1 AND [CountryCode] IS NULL) OR ([CountryCode] = @Original_CountryCode)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Symbol" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Symbol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StockExchangeCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StockExchangeCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_StockExchangeCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="StockExchangeCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountryCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Paper] ([ID], [Name], [Type], [Symbol], [StockExchangeCode], [CountryCode]) VALUES (@ID, @Name, @Type, @Symbol, @StockExchangeCode, @CountryCode);
SELECT ID, Name, Type, Symbol, StockExchangeCode, CountryCode FROM Paper WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Symbol" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Symbol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@StockExchangeCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="StockExchangeCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, Type, Symbol, StockExchangeCode, CountryCode FROM dbo.Paper</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Paper] SET [ID] = @ID, [Name] = @Name, [Type] = @Type, [Symbol] = @Symbol, [StockExchangeCode] = @StockExchangeCode, [CountryCode] = @CountryCode WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([Type] = @Original_Type) AND ([Symbol] = @Original_Symbol) AND ((@IsNull_StockExchangeCode = 1 AND [StockExchangeCode] IS NULL) OR ([StockExchangeCode] = @Original_StockExchangeCode)) AND ((@IsNull_CountryCode = 1 AND [CountryCode] IS NULL) OR ([CountryCode] = @Original_CountryCode)));
SELECT ID, Name, Type, Symbol, StockExchangeCode, CountryCode FROM Paper WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Symbol" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Symbol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@StockExchangeCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="StockExchangeCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Symbol" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Symbol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StockExchangeCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StockExchangeCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_StockExchangeCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="StockExchangeCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountryCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Symbol" DataSetColumn="Symbol" />
              <Mapping SourceColumn="StockExchangeCode" DataSetColumn="StockExchangeCode" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PortfolioTableAdapter" GeneratorDataComponentClassName="PortfolioTableAdapter" Name="Portfolio" UserDataComponentName="PortfolioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Portfolio" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Portfolio] WHERE (([ID] = @Original_ID) AND ([InvestmentHouseID] = @Original_InvestmentHouseID) AND ([ManagerId] = @Original_ManagerId) AND ([TypeID] = @Original_TypeID) AND ([CurrencyCode] = @Original_CurrencyCode) AND ([QuantityPortfolioID] = @Original_QuantityPortfolioID) AND ([TaxesSourceID] = @Original_TaxesSourceID) AND ([CommissionsSourceID] = @Original_CommissionsSourceID) AND ([StocksQuotesSourceID] = @Original_StocksQuotesSourceID) AND ([DividendQuotesSourceID] = @Original_DividendQuotesSourceID) AND ([ExchangeRatesQuotesSourceID] = @Original_ExchangeRatesQuotesSourceID) AND ([NotStocksQuotesSourceID] = @Original_NotStocksQuotesSourceID) AND ([CashPortfolioID] = @Original_CashPortfolioID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_InvestmentHouseID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="InvestmentHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ManagerId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ManagerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TypeID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_QuantityPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="QuantityPortfolioID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TaxesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaxesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CommissionsSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CommissionsSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_StocksQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="StocksQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_DividendQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="DividendQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ExchangeRatesQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ExchangeRatesQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_NotStocksQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="NotStocksQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CashPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CashPortfolioID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Portfolio] ([ID], [InvestmentHouseID], [ManagerId], [TypeID], [CurrencyCode], [QuantityPortfolioID], [TaxesSourceID], [CommissionsSourceID], [StocksQuotesSourceID], [DividendQuotesSourceID], [ExchangeRatesQuotesSourceID], [NotStocksQuotesSourceID], [CashPortfolioID]) VALUES (@ID, @InvestmentHouseID, @ManagerId, @TypeID, @CurrencyCode, @QuantityPortfolioID, @TaxesSourceID, @CommissionsSourceID, @StocksQuotesSourceID, @DividendQuotesSourceID, @ExchangeRatesQuotesSourceID, @NotStocksQuotesSourceID, @CashPortfolioID);
SELECT ID, InvestmentHouseID, ManagerId, TypeID, CurrencyCode, QuantityPortfolioID, TaxesSourceID, CommissionsSourceID, StocksQuotesSourceID, DividendQuotesSourceID, ExchangeRatesQuotesSourceID, NotStocksQuotesSourceID, CashPortfolioID FROM Portfolio WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@InvestmentHouseID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="InvestmentHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ManagerId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ManagerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TypeID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@QuantityPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="QuantityPortfolioID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TaxesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaxesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CommissionsSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CommissionsSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@StocksQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="StocksQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@DividendQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="DividendQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ExchangeRatesQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ExchangeRatesQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@NotStocksQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="NotStocksQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CashPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CashPortfolioID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, InvestmentHouseID, ManagerId, TypeID, CurrencyCode, QuantityPortfolioID, TaxesSourceID, CommissionsSourceID, StocksQuotesSourceID, DividendQuotesSourceID, ExchangeRatesQuotesSourceID, NotStocksQuotesSourceID, CashPortfolioID FROM dbo.Portfolio</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Portfolio] SET [ID] = @ID, [InvestmentHouseID] = @InvestmentHouseID, [ManagerId] = @ManagerId, [TypeID] = @TypeID, [CurrencyCode] = @CurrencyCode, [QuantityPortfolioID] = @QuantityPortfolioID, [TaxesSourceID] = @TaxesSourceID, [CommissionsSourceID] = @CommissionsSourceID, [StocksQuotesSourceID] = @StocksQuotesSourceID, [DividendQuotesSourceID] = @DividendQuotesSourceID, [ExchangeRatesQuotesSourceID] = @ExchangeRatesQuotesSourceID, [NotStocksQuotesSourceID] = @NotStocksQuotesSourceID, [CashPortfolioID] = @CashPortfolioID WHERE (([ID] = @Original_ID) AND ([InvestmentHouseID] = @Original_InvestmentHouseID) AND ([ManagerId] = @Original_ManagerId) AND ([TypeID] = @Original_TypeID) AND ([CurrencyCode] = @Original_CurrencyCode) AND ([QuantityPortfolioID] = @Original_QuantityPortfolioID) AND ([TaxesSourceID] = @Original_TaxesSourceID) AND ([CommissionsSourceID] = @Original_CommissionsSourceID) AND ([StocksQuotesSourceID] = @Original_StocksQuotesSourceID) AND ([DividendQuotesSourceID] = @Original_DividendQuotesSourceID) AND ([ExchangeRatesQuotesSourceID] = @Original_ExchangeRatesQuotesSourceID) AND ([NotStocksQuotesSourceID] = @Original_NotStocksQuotesSourceID) AND ([CashPortfolioID] = @Original_CashPortfolioID));
SELECT ID, InvestmentHouseID, ManagerId, TypeID, CurrencyCode, QuantityPortfolioID, TaxesSourceID, CommissionsSourceID, StocksQuotesSourceID, DividendQuotesSourceID, ExchangeRatesQuotesSourceID, NotStocksQuotesSourceID, CashPortfolioID FROM Portfolio WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@InvestmentHouseID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="InvestmentHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ManagerId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ManagerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TypeID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@QuantityPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="QuantityPortfolioID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TaxesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaxesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CommissionsSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CommissionsSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@StocksQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="StocksQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@DividendQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="DividendQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ExchangeRatesQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ExchangeRatesQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@NotStocksQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="NotStocksQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CashPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CashPortfolioID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_InvestmentHouseID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="InvestmentHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ManagerId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ManagerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TypeID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_QuantityPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="QuantityPortfolioID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TaxesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaxesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CommissionsSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CommissionsSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_StocksQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="StocksQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_DividendQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="DividendQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ExchangeRatesQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ExchangeRatesQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_NotStocksQuotesSourceID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="NotStocksQuotesSourceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CashPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CashPortfolioID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="InvestmentHouseID" DataSetColumn="InvestmentHouseID" />
              <Mapping SourceColumn="ManagerId" DataSetColumn="ManagerId" />
              <Mapping SourceColumn="TypeID" DataSetColumn="TypeID" />
              <Mapping SourceColumn="CurrencyCode" DataSetColumn="CurrencyCode" />
              <Mapping SourceColumn="QuantityPortfolioID" DataSetColumn="QuantityPortfolioID" />
              <Mapping SourceColumn="TaxesSourceID" DataSetColumn="TaxesSourceID" />
              <Mapping SourceColumn="CommissionsSourceID" DataSetColumn="CommissionsSourceID" />
              <Mapping SourceColumn="StocksQuotesSourceID" DataSetColumn="StocksQuotesSourceID" />
              <Mapping SourceColumn="DividendQuotesSourceID" DataSetColumn="DividendQuotesSourceID" />
              <Mapping SourceColumn="ExchangeRatesQuotesSourceID" DataSetColumn="ExchangeRatesQuotesSourceID" />
              <Mapping SourceColumn="NotStocksQuotesSourceID" DataSetColumn="NotStocksQuotesSourceID" />
              <Mapping SourceColumn="CashPortfolioID" DataSetColumn="CashPortfolioID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PortfolioTypeTableAdapter" GeneratorDataComponentClassName="PortfolioTypeTableAdapter" Name="PortfolioType" UserDataComponentName="PortfolioTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.PortfolioType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PortfolioType] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PortfolioType] ([ID], [Name]) VALUES (@ID, @Name);
SELECT ID, Name FROM PortfolioType WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name FROM dbo.PortfolioType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PortfolioType] SET [ID] = @ID, [Name] = @Name WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name));
SELECT ID, Name FROM PortfolioType WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QuantityPortfolioTableAdapter" GeneratorDataComponentClassName="QuantityPortfolioTableAdapter" Name="QuantityPortfolio" UserDataComponentName="QuantityPortfolioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.QuantityPortfolio" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[QuantityPortfolio] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[QuantityPortfolio] ([ID], [Name]) VALUES (@ID, @Name);
SELECT ID, Name FROM QuantityPortfolio WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name FROM dbo.QuantityPortfolio</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[QuantityPortfolio] SET [ID] = @ID, [Name] = @Name WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name));
SELECT ID, Name FROM QuantityPortfolio WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QuantityTransactionTableAdapter" GeneratorDataComponentClassName="QuantityTransactionTableAdapter" Name="QuantityTransaction" UserDataComponentName="QuantityTransactionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.QuantityTransaction" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[QuantityTransaction] WHERE (([QuantityPortfolioID] = @Original_QuantityPortfolioID) AND ([PackageID] = @Original_PackageID) AND ([TransactionID] = @Original_TransactionID) AND ([PaperID] = @Original_PaperID) AND ([ActionID] = @Original_ActionID) AND ([ValueDate] = @Original_ValueDate) AND ([Quantity] = @Original_Quantity))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_QuantityPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="QuantityPortfolioID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValueDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[QuantityTransaction] ([QuantityPortfolioID], [PackageID], [TransactionID], [PaperID], [ActionID], [ValueDate], [Quantity]) VALUES (@QuantityPortfolioID, @PackageID, @TransactionID, @PaperID, @ActionID, @ValueDate, @Quantity);
SELECT QuantityPortfolioID, PackageID, TransactionID, PaperID, ActionID, ValueDate, Quantity FROM QuantityTransaction WHERE (TransactionID = @TransactionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@QuantityPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="QuantityPortfolioID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValueDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT QuantityPortfolioID, PackageID, TransactionID, PaperID, ActionID, ValueDate, Quantity FROM dbo.QuantityTransaction</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[QuantityTransaction] SET [QuantityPortfolioID] = @QuantityPortfolioID, [PackageID] = @PackageID, [TransactionID] = @TransactionID, [PaperID] = @PaperID, [ActionID] = @ActionID, [ValueDate] = @ValueDate, [Quantity] = @Quantity WHERE (([QuantityPortfolioID] = @Original_QuantityPortfolioID) AND ([PackageID] = @Original_PackageID) AND ([TransactionID] = @Original_TransactionID) AND ([PaperID] = @Original_PaperID) AND ([ActionID] = @Original_ActionID) AND ([ValueDate] = @Original_ValueDate) AND ([Quantity] = @Original_Quantity));
SELECT QuantityPortfolioID, PackageID, TransactionID, PaperID, ActionID, ValueDate, Quantity FROM QuantityTransaction WHERE (TransactionID = @TransactionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@QuantityPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="QuantityPortfolioID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValueDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_QuantityPortfolioID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="QuantityPortfolioID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ActionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ActionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValueDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ValueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="QuantityPortfolioID" DataSetColumn="QuantityPortfolioID" />
              <Mapping SourceColumn="PackageID" DataSetColumn="PackageID" />
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
              <Mapping SourceColumn="PaperID" DataSetColumn="PaperID" />
              <Mapping SourceColumn="ActionID" DataSetColumn="ActionID" />
              <Mapping SourceColumn="ValueDate" DataSetColumn="ValueDate" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SourceTableAdapter" GeneratorDataComponentClassName="SourceTableAdapter" Name="Source" UserDataComponentName="SourceTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.Source" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Source] WHERE (([ID] = @Original_ID) AND ([Description] = @Original_Description) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)) AND ((@IsNull_Location = 1 AND [Location] IS NULL) OR ([Location] = @Original_Location)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Location" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Source] ([ID], [Description], [Type], [Location]) VALUES (@ID, @Description, @Type, @Location);
SELECT ID, Description, Type, Location FROM Source WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Description, Type, Location FROM dbo.Source</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Source] SET [ID] = @ID, [Description] = @Description, [Type] = @Type, [Location] = @Location WHERE (([ID] = @Original_ID) AND ([Description] = @Original_Description) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)) AND ((@IsNull_Location = 1 AND [Location] IS NULL) OR ([Location] = @Original_Location)));
SELECT ID, Description, Type, Location FROM Source WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Location" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Location" DataSetColumn="Location" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StockExchangeTableAdapter" GeneratorDataComponentClassName="StockExchangeTableAdapter" Name="StockExchange" UserDataComponentName="StockExchangeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.StockExchange" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[StockExchange] WHERE (([Code] = @Original_Code) AND ([Name] = @Original_Name) AND ([CountryCode] = @Original_CountryCode))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[StockExchange] ([Code], [Name], [CountryCode]) VALUES (@Code, @Name, @CountryCode);
SELECT Code, Name, CountryCode FROM StockExchange WHERE (Code = @Code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code, Name, CountryCode FROM dbo.StockExchange</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[StockExchange] SET [Code] = @Code, [Name] = @Name, [CountryCode] = @CountryCode WHERE (([Code] = @Original_Code) AND ([Name] = @Original_Name) AND ([CountryCode] = @Original_CountryCode));
SELECT Code, Name, CountryCode FROM StockExchange WHERE (Code = @Code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_CountryCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StocksQuoteTableAdapter" GeneratorDataComponentClassName="StocksQuoteTableAdapter" Name="StocksQuote" UserDataComponentName="StocksQuoteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IPAMSConnectionString (Settings)" DbObjectName="IPAMS.dbo.StocksQuote" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[StocksQuote] WHERE (([PaperID] = @Original_PaperID) AND ([Date] = @Original_Date) AND ([ClosingRate] = @Original_ClosingRate) AND ([PackageID] = @Original_PackageID) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ClosingRate" Precision="12" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="ClosingRate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[StocksQuote] ([PaperID], [Date], [ClosingRate], [PackageID], [TransactionID]) VALUES (@PaperID, @Date, @ClosingRate, @PackageID, @TransactionID);
SELECT PaperID, Date, ClosingRate, PackageID, TransactionID FROM StocksQuote WHERE (Date = @Date) AND (PackageID = @PackageID) AND (PaperID = @PaperID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ClosingRate" Precision="12" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="ClosingRate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PaperID, Date, ClosingRate, PackageID, TransactionID FROM dbo.StocksQuote</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[StocksQuote] SET [PaperID] = @PaperID, [Date] = @Date, [ClosingRate] = @ClosingRate, [PackageID] = @PackageID, [TransactionID] = @TransactionID WHERE (([PaperID] = @Original_PaperID) AND ([Date] = @Original_Date) AND ([ClosingRate] = @Original_ClosingRate) AND ([PackageID] = @Original_PackageID) AND ((@IsNull_TransactionID = 1 AND [TransactionID] IS NULL) OR ([TransactionID] = @Original_TransactionID)));
SELECT PaperID, Date, ClosingRate, PackageID, TransactionID FROM StocksQuote WHERE (Date = @Date) AND (PackageID = @PackageID) AND (PaperID = @PaperID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ClosingRate" Precision="12" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="ClosingRate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PaperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PaperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ClosingRate" Precision="12" ProviderType="Decimal" Scale="4" Size="0" SourceColumn="ClosingRate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PackageID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PackageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PaperID" DataSetColumn="PaperID" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
              <Mapping SourceColumn="ClosingRate" DataSetColumn="ClosingRate" />
              <Mapping SourceColumn="PackageID" DataSetColumn="PackageID" />
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="IPAMSDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="IPAMSDataSet" msprop:Generator_DataSetName="IPAMSDataSet" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Action" msprop:Generator_UserTableName="Action" msprop:Generator_RowDeletedName="ActionRowDeleted" msprop:Generator_TableClassName="ActionDataTable" msprop:Generator_RowChangedName="ActionRowChanged" msprop:Generator_RowClassName="ActionRow" msprop:Generator_RowChangingName="ActionRowChanging" msprop:Generator_RowEvArgName="ActionRowChangeEvent" msprop:Generator_RowEvHandlerName="ActionRowChangeEventHandler" msprop:Generator_TablePropName="Action" msprop:Generator_TableVarName="tableAction" msprop:Generator_RowDeletingName="ActionRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tax" msprop:Generator_UserTableName="Tax" msprop:Generator_RowDeletedName="TaxRowDeleted" msprop:Generator_TableClassName="TaxDataTable" msprop:Generator_RowChangedName="TaxRowChanged" msprop:Generator_RowClassName="TaxRow" msprop:Generator_RowChangingName="TaxRowChanging" msprop:Generator_RowEvArgName="TaxRowChangeEvent" msprop:Generator_RowEvHandlerName="TaxRowChangeEventHandler" msprop:Generator_TablePropName="Tax" msprop:Generator_TableVarName="tableTax" msprop:Generator_RowDeletingName="TaxRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionId" msprop:Generator_UserColumnName="ActionId" msprop:Generator_ColumnPropNameInRow="ActionId" msprop:Generator_ColumnVarNameInTable="columnActionId" msprop:Generator_ColumnPropNameInTable="ActionIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rate" msprop:Generator_UserColumnName="Rate" msprop:Generator_ColumnPropNameInRow="Rate" msprop:Generator_ColumnVarNameInTable="columnRate" msprop:Generator_ColumnPropNameInTable="RateColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ValidFromDate" msprop:Generator_UserColumnName="ValidFromDate" msprop:Generator_ColumnPropNameInRow="ValidFromDate" msprop:Generator_ColumnVarNameInTable="columnValidFromDate" msprop:Generator_ColumnPropNameInTable="ValidFromDateColumn" type="xs:dateTime" />
              <xs:element name="ValidToDate" msprop:Generator_UserColumnName="ValidToDate" msprop:Generator_ColumnPropNameInRow="ValidToDate" msprop:Generator_ColumnVarNameInTable="columnValidToDate" msprop:Generator_ColumnPropNameInTable="ValidToDateColumn" type="xs:dateTime" />
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CashAction" msprop:Generator_UserTableName="CashAction" msprop:Generator_RowDeletedName="CashActionRowDeleted" msprop:Generator_TableClassName="CashActionDataTable" msprop:Generator_RowChangedName="CashActionRowChanged" msprop:Generator_RowClassName="CashActionRow" msprop:Generator_RowChangingName="CashActionRowChanging" msprop:Generator_RowEvArgName="CashActionRowChangeEvent" msprop:Generator_RowEvHandlerName="CashActionRowChangeEventHandler" msprop:Generator_TablePropName="CashAction" msprop:Generator_TableVarName="tableCashAction" msprop:Generator_RowDeletingName="CashActionRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CashPortfolio" msprop:Generator_UserTableName="CashPortfolio" msprop:Generator_RowDeletedName="CashPortfolioRowDeleted" msprop:Generator_TableClassName="CashPortfolioDataTable" msprop:Generator_RowChangedName="CashPortfolioRowChanged" msprop:Generator_RowClassName="CashPortfolioRow" msprop:Generator_RowChangingName="CashPortfolioRowChanging" msprop:Generator_RowEvArgName="CashPortfolioRowChangeEvent" msprop:Generator_RowEvHandlerName="CashPortfolioRowChangeEventHandler" msprop:Generator_TablePropName="CashPortfolio" msprop:Generator_TableVarName="tableCashPortfolio" msprop:Generator_RowDeletingName="CashPortfolioRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CashTransaction" msprop:Generator_UserTableName="CashTransaction" msprop:Generator_RowDeletedName="CashTransactionRowDeleted" msprop:Generator_TableClassName="CashTransactionDataTable" msprop:Generator_RowChangedName="CashTransactionRowChanged" msprop:Generator_RowClassName="CashTransactionRow" msprop:Generator_RowChangingName="CashTransactionRowChanging" msprop:Generator_RowEvArgName="CashTransactionRowChangeEvent" msprop:Generator_RowEvHandlerName="CashTransactionRowChangeEventHandler" msprop:Generator_TablePropName="CashTransaction" msprop:Generator_TableVarName="tableCashTransaction" msprop:Generator_RowDeletingName="CashTransactionRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CashPotfolioID" msprop:Generator_UserColumnName="CashPotfolioID" msprop:Generator_ColumnPropNameInRow="CashPotfolioID" msprop:Generator_ColumnVarNameInTable="columnCashPotfolioID" msprop:Generator_ColumnPropNameInTable="CashPotfolioIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionID" msprop:Generator_UserColumnName="ActionID" msprop:Generator_ColumnPropNameInRow="ActionID" msprop:Generator_ColumnVarNameInTable="columnActionID" msprop:Generator_ColumnPropNameInTable="ActionIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Amount" msprop:Generator_UserColumnName="Amount" msprop:Generator_ColumnPropNameInRow="Amount" msprop:Generator_ColumnVarNameInTable="columnAmount" msprop:Generator_ColumnPropNameInTable="AmountColumn" type="xs:int" />
              <xs:element name="CurrencyCode" msprop:Generator_UserColumnName="CurrencyCode" msprop:Generator_ColumnPropNameInRow="CurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCurrencyCode" msprop:Generator_ColumnPropNameInTable="CurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateTime" msprop:Generator_UserColumnName="DateTime" msprop:Generator_ColumnPropNameInRow="DateTime" msprop:Generator_ColumnVarNameInTable="columnDateTime" msprop:Generator_ColumnPropNameInTable="DateTimeColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Commission" msprop:Generator_UserTableName="Commission" msprop:Generator_RowDeletedName="CommissionRowDeleted" msprop:Generator_TableClassName="CommissionDataTable" msprop:Generator_RowChangedName="CommissionRowChanged" msprop:Generator_RowClassName="CommissionRow" msprop:Generator_RowChangingName="CommissionRowChanging" msprop:Generator_RowEvArgName="CommissionRowChangeEvent" msprop:Generator_RowEvHandlerName="CommissionRowChangeEventHandler" msprop:Generator_TablePropName="Commission" msprop:Generator_TableVarName="tableCommission" msprop:Generator_RowDeletingName="CommissionRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceID" msprop:Generator_UserColumnName="SourceID" msprop:Generator_ColumnPropNameInRow="SourceID" msprop:Generator_ColumnVarNameInTable="columnSourceID" msprop:Generator_ColumnPropNameInTable="SourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvestmentHouseID" msprop:Generator_UserColumnName="InvestmentHouseID" msprop:Generator_ColumnPropNameInRow="InvestmentHouseID" msprop:Generator_ColumnVarNameInTable="columnInvestmentHouseID" msprop:Generator_ColumnPropNameInTable="InvestmentHouseIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionID" msprop:Generator_UserColumnName="ActionID" msprop:Generator_ColumnPropNameInRow="ActionID" msprop:Generator_ColumnVarNameInTable="columnActionID" msprop:Generator_ColumnPropNameInTable="ActionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrencyCode" msprop:Generator_UserColumnName="CurrencyCode" msprop:Generator_ColumnPropNameInRow="CurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCurrencyCode" msprop:Generator_ColumnPropNameInTable="CurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Min" msprop:Generator_UserColumnName="Min" msprop:Generator_ColumnPropNameInRow="Min" msprop:Generator_ColumnVarNameInTable="columnMin" msprop:Generator_ColumnPropNameInTable="MinColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Max" msprop:Generator_UserColumnName="Max" msprop:Generator_ColumnPropNameInRow="Max" msprop:Generator_ColumnVarNameInTable="columnMax" msprop:Generator_ColumnPropNameInTable="MaxColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Rate" msprop:Generator_UserColumnName="Rate" msprop:Generator_ColumnPropNameInRow="Rate" msprop:Generator_ColumnVarNameInTable="columnRate" msprop:Generator_ColumnPropNameInTable="RateColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PeriodMonths" msprop:Generator_UserColumnName="PeriodMonths" msprop:Generator_ColumnPropNameInRow="PeriodMonths" msprop:Generator_ColumnVarNameInTable="columnPeriodMonths" msprop:Generator_ColumnPropNameInTable="PeriodMonthsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="PerOneStock" msprop:Generator_UserColumnName="PerOneStock" msprop:Generator_ColumnPropNameInRow="PerOneStock" msprop:Generator_ColumnVarNameInTable="columnPerOneStock" msprop:Generator_ColumnPropNameInTable="PerOneStockColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ValidFromDate" msprop:Generator_UserColumnName="ValidFromDate" msprop:Generator_ColumnPropNameInRow="ValidFromDate" msprop:Generator_ColumnVarNameInTable="columnValidFromDate" msprop:Generator_ColumnPropNameInTable="ValidFromDateColumn" type="xs:dateTime" />
              <xs:element name="ValidToDate" msprop:Generator_UserColumnName="ValidToDate" msprop:Generator_ColumnPropNameInRow="ValidToDate" msprop:Generator_ColumnVarNameInTable="columnValidToDate" msprop:Generator_ColumnPropNameInTable="ValidToDateColumn" type="xs:dateTime" />
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Country" msprop:Generator_UserTableName="Country" msprop:Generator_RowDeletedName="CountryRowDeleted" msprop:Generator_TableClassName="CountryDataTable" msprop:Generator_RowChangedName="CountryRowChanged" msprop:Generator_RowClassName="CountryRow" msprop:Generator_RowChangingName="CountryRowChanging" msprop:Generator_RowEvArgName="CountryRowChangeEvent" msprop:Generator_RowEvHandlerName="CountryRowChangeEventHandler" msprop:Generator_TablePropName="Country" msprop:Generator_TableVarName="tableCountry" msprop:Generator_RowDeletingName="CountryRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrencyCode" msprop:Generator_UserColumnName="CurrencyCode" msprop:Generator_ColumnPropNameInRow="CurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCurrencyCode" msprop:Generator_ColumnPropNameInTable="CurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Currency" msprop:Generator_UserTableName="Currency" msprop:Generator_RowDeletedName="CurrencyRowDeleted" msprop:Generator_TableClassName="CurrencyDataTable" msprop:Generator_RowChangedName="CurrencyRowChanged" msprop:Generator_RowClassName="CurrencyRow" msprop:Generator_RowChangingName="CurrencyRowChanging" msprop:Generator_RowEvArgName="CurrencyRowChangeEvent" msprop:Generator_RowEvHandlerName="CurrencyRowChangeEventHandler" msprop:Generator_TablePropName="Currency" msprop:Generator_TableVarName="tableCurrency" msprop:Generator_RowDeletingName="CurrencyRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DividendsQuote" msprop:Generator_UserTableName="DividendsQuote" msprop:Generator_RowDeletedName="DividendsQuoteRowDeleted" msprop:Generator_TableClassName="DividendsQuoteDataTable" msprop:Generator_RowChangedName="DividendsQuoteRowChanged" msprop:Generator_RowClassName="DividendsQuoteRow" msprop:Generator_RowChangingName="DividendsQuoteRowChanging" msprop:Generator_RowEvArgName="DividendsQuoteRowChangeEvent" msprop:Generator_RowEvHandlerName="DividendsQuoteRowChangeEventHandler" msprop:Generator_TablePropName="DividendsQuote" msprop:Generator_TableVarName="tableDividendsQuote" msprop:Generator_RowDeletingName="DividendsQuoteRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PaperID" msprop:Generator_UserColumnName="PaperID" msprop:Generator_ColumnPropNameInRow="PaperID" msprop:Generator_ColumnVarNameInTable="columnPaperID" msprop:Generator_ColumnPropNameInTable="PaperIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExDate" msprop:Generator_UserColumnName="ExDate" msprop:Generator_ColumnPropNameInRow="ExDate" msprop:Generator_ColumnVarNameInTable="columnExDate" msprop:Generator_ColumnPropNameInTable="ExDateColumn" type="xs:dateTime" />
              <xs:element name="Value" msprop:Generator_UserColumnName="Value" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInTable="ValueColumn" type="xs:decimal" />
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ExchangeRatesQuote" msprop:Generator_UserTableName="ExchangeRatesQuote" msprop:Generator_RowDeletedName="ExchangeRatesQuoteRowDeleted" msprop:Generator_TableClassName="ExchangeRatesQuoteDataTable" msprop:Generator_RowChangedName="ExchangeRatesQuoteRowChanged" msprop:Generator_RowClassName="ExchangeRatesQuoteRow" msprop:Generator_RowChangingName="ExchangeRatesQuoteRowChanging" msprop:Generator_RowEvArgName="ExchangeRatesQuoteRowChangeEvent" msprop:Generator_RowEvHandlerName="ExchangeRatesQuoteRowChangeEventHandler" msprop:Generator_TablePropName="ExchangeRatesQuote" msprop:Generator_TableVarName="tableExchangeRatesQuote" msprop:Generator_RowDeletingName="ExchangeRatesQuoteRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SourceCurrencyCode" msprop:Generator_UserColumnName="SourceCurrencyCode" msprop:Generator_ColumnPropNameInRow="SourceCurrencyCode" msprop:Generator_ColumnVarNameInTable="columnSourceCurrencyCode" msprop:Generator_ColumnPropNameInTable="SourceCurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TargetCurrencyCode" msprop:Generator_UserColumnName="TargetCurrencyCode" msprop:Generator_ColumnPropNameInRow="TargetCurrencyCode" msprop:Generator_ColumnVarNameInTable="columnTargetCurrencyCode" msprop:Generator_ColumnPropNameInTable="TargetCurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" type="xs:dateTime" />
              <xs:element name="Rate" msprop:Generator_UserColumnName="Rate" msprop:Generator_ColumnPropNameInRow="Rate" msprop:Generator_ColumnVarNameInTable="columnRate" msprop:Generator_ColumnPropNameInTable="RateColumn" type="xs:decimal" />
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InvestmentHouse" msprop:Generator_UserTableName="InvestmentHouse" msprop:Generator_RowDeletedName="InvestmentHouseRowDeleted" msprop:Generator_TableClassName="InvestmentHouseDataTable" msprop:Generator_RowChangedName="InvestmentHouseRowChanged" msprop:Generator_RowClassName="InvestmentHouseRow" msprop:Generator_RowChangingName="InvestmentHouseRowChanging" msprop:Generator_RowEvArgName="InvestmentHouseRowChangeEvent" msprop:Generator_RowEvHandlerName="InvestmentHouseRowChangeEventHandler" msprop:Generator_TablePropName="InvestmentHouse" msprop:Generator_TableVarName="tableInvestmentHouse" msprop:Generator_RowDeletingName="InvestmentHouseRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="URL" msprop:Generator_UserColumnName="URL" msprop:Generator_ColumnPropNameInRow="URL" msprop:Generator_ColumnVarNameInTable="columnURL" msprop:Generator_ColumnPropNameInTable="URLColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Manager" msprop:Generator_UserTableName="Manager" msprop:Generator_RowDeletedName="ManagerRowDeleted" msprop:Generator_TableClassName="ManagerDataTable" msprop:Generator_RowChangedName="ManagerRowChanged" msprop:Generator_RowClassName="ManagerRow" msprop:Generator_RowChangingName="ManagerRowChanging" msprop:Generator_RowEvArgName="ManagerRowChangeEvent" msprop:Generator_RowEvHandlerName="ManagerRowChangeEventHandler" msprop:Generator_TablePropName="Manager" msprop:Generator_TableVarName="tableManager" msprop:Generator_RowDeletingName="ManagerRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MobilePhone" msprop:Generator_UserColumnName="MobilePhone" msprop:Generator_ColumnPropNameInRow="MobilePhone" msprop:Generator_ColumnVarNameInTable="columnMobilePhone" msprop:Generator_ColumnPropNameInTable="MobilePhoneColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Package" msprop:Generator_UserTableName="Package" msprop:Generator_RowDeletedName="PackageRowDeleted" msprop:Generator_TableClassName="PackageDataTable" msprop:Generator_RowChangedName="PackageRowChanged" msprop:Generator_RowClassName="PackageRow" msprop:Generator_RowChangingName="PackageRowChanging" msprop:Generator_RowEvArgName="PackageRowChangeEvent" msprop:Generator_RowEvHandlerName="PackageRowChangeEventHandler" msprop:Generator_TablePropName="Package" msprop:Generator_TableVarName="tablePackage" msprop:Generator_RowDeletingName="PackageRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SourceID" msprop:Generator_UserColumnName="SourceID" msprop:Generator_ColumnPropNameInRow="SourceID" msprop:Generator_ColumnVarNameInTable="columnSourceID" msprop:Generator_ColumnPropNameInTable="SourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateTime" msprop:Generator_UserColumnName="DateTime" msprop:Generator_ColumnPropNameInRow="DateTime" msprop:Generator_ColumnVarNameInTable="columnDateTime" msprop:Generator_ColumnPropNameInTable="DateTimeColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Paper" msprop:Generator_UserTableName="Paper" msprop:Generator_RowDeletedName="PaperRowDeleted" msprop:Generator_TableClassName="PaperDataTable" msprop:Generator_RowChangedName="PaperRowChanged" msprop:Generator_RowClassName="PaperRow" msprop:Generator_RowChangingName="PaperRowChanging" msprop:Generator_RowEvArgName="PaperRowChangeEvent" msprop:Generator_RowEvHandlerName="PaperRowChangeEventHandler" msprop:Generator_TablePropName="Paper" msprop:Generator_TableVarName="tablePaper" msprop:Generator_RowDeletingName="PaperRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Symbol" msprop:Generator_UserColumnName="Symbol" msprop:Generator_ColumnPropNameInRow="Symbol" msprop:Generator_ColumnVarNameInTable="columnSymbol" msprop:Generator_ColumnPropNameInTable="SymbolColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StockExchangeCode" msprop:Generator_UserColumnName="StockExchangeCode" msprop:Generator_ColumnPropNameInRow="StockExchangeCode" msprop:Generator_ColumnVarNameInTable="columnStockExchangeCode" msprop:Generator_ColumnPropNameInTable="StockExchangeCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Portfolio" msprop:Generator_UserTableName="Portfolio" msprop:Generator_RowDeletedName="PortfolioRowDeleted" msprop:Generator_TableClassName="PortfolioDataTable" msprop:Generator_RowChangedName="PortfolioRowChanged" msprop:Generator_RowClassName="PortfolioRow" msprop:Generator_RowChangingName="PortfolioRowChanging" msprop:Generator_RowEvArgName="PortfolioRowChangeEvent" msprop:Generator_RowEvHandlerName="PortfolioRowChangeEventHandler" msprop:Generator_TablePropName="Portfolio" msprop:Generator_TableVarName="tablePortfolio" msprop:Generator_RowDeletingName="PortfolioRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvestmentHouseID" msprop:Generator_UserColumnName="InvestmentHouseID" msprop:Generator_ColumnPropNameInRow="InvestmentHouseID" msprop:Generator_ColumnVarNameInTable="columnInvestmentHouseID" msprop:Generator_ColumnPropNameInTable="InvestmentHouseIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManagerId" msprop:Generator_UserColumnName="ManagerId" msprop:Generator_ColumnPropNameInRow="ManagerId" msprop:Generator_ColumnVarNameInTable="columnManagerId" msprop:Generator_ColumnPropNameInTable="ManagerIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TypeID" msprop:Generator_UserColumnName="TypeID" msprop:Generator_ColumnPropNameInRow="TypeID" msprop:Generator_ColumnVarNameInTable="columnTypeID" msprop:Generator_ColumnPropNameInTable="TypeIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrencyCode" msprop:Generator_UserColumnName="CurrencyCode" msprop:Generator_ColumnPropNameInRow="CurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCurrencyCode" msprop:Generator_ColumnPropNameInTable="CurrencyCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="QuantityPortfolioID" msprop:Generator_UserColumnName="QuantityPortfolioID" msprop:Generator_ColumnPropNameInRow="QuantityPortfolioID" msprop:Generator_ColumnVarNameInTable="columnQuantityPortfolioID" msprop:Generator_ColumnPropNameInTable="QuantityPortfolioIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaxesSourceID" msprop:Generator_UserColumnName="TaxesSourceID" msprop:Generator_ColumnPropNameInRow="TaxesSourceID" msprop:Generator_ColumnVarNameInTable="columnTaxesSourceID" msprop:Generator_ColumnPropNameInTable="TaxesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CommissionsSourceID" msprop:Generator_UserColumnName="CommissionsSourceID" msprop:Generator_ColumnPropNameInRow="CommissionsSourceID" msprop:Generator_ColumnVarNameInTable="columnCommissionsSourceID" msprop:Generator_ColumnPropNameInTable="CommissionsSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StocksQuotesSourceID" msprop:Generator_UserColumnName="StocksQuotesSourceID" msprop:Generator_ColumnPropNameInRow="StocksQuotesSourceID" msprop:Generator_ColumnVarNameInTable="columnStocksQuotesSourceID" msprop:Generator_ColumnPropNameInTable="StocksQuotesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DividendQuotesSourceID" msprop:Generator_UserColumnName="DividendQuotesSourceID" msprop:Generator_ColumnPropNameInRow="DividendQuotesSourceID" msprop:Generator_ColumnVarNameInTable="columnDividendQuotesSourceID" msprop:Generator_ColumnPropNameInTable="DividendQuotesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExchangeRatesQuotesSourceID" msprop:Generator_UserColumnName="ExchangeRatesQuotesSourceID" msprop:Generator_ColumnPropNameInRow="ExchangeRatesQuotesSourceID" msprop:Generator_ColumnVarNameInTable="columnExchangeRatesQuotesSourceID" msprop:Generator_ColumnPropNameInTable="ExchangeRatesQuotesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NotStocksQuotesSourceID" msprop:Generator_UserColumnName="NotStocksQuotesSourceID" msprop:Generator_ColumnPropNameInRow="NotStocksQuotesSourceID" msprop:Generator_ColumnVarNameInTable="columnNotStocksQuotesSourceID" msprop:Generator_ColumnPropNameInTable="NotStocksQuotesSourceIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CashPortfolioID" msprop:Generator_UserColumnName="CashPortfolioID" msprop:Generator_ColumnPropNameInRow="CashPortfolioID" msprop:Generator_ColumnVarNameInTable="columnCashPortfolioID" msprop:Generator_ColumnPropNameInTable="CashPortfolioIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PortfolioType" msprop:Generator_UserTableName="PortfolioType" msprop:Generator_RowDeletedName="PortfolioTypeRowDeleted" msprop:Generator_TableClassName="PortfolioTypeDataTable" msprop:Generator_RowChangedName="PortfolioTypeRowChanged" msprop:Generator_RowClassName="PortfolioTypeRow" msprop:Generator_RowChangingName="PortfolioTypeRowChanging" msprop:Generator_RowEvArgName="PortfolioTypeRowChangeEvent" msprop:Generator_RowEvHandlerName="PortfolioTypeRowChangeEventHandler" msprop:Generator_TablePropName="PortfolioType" msprop:Generator_TableVarName="tablePortfolioType" msprop:Generator_RowDeletingName="PortfolioTypeRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="QuantityPortfolio" msprop:Generator_UserTableName="QuantityPortfolio" msprop:Generator_RowDeletedName="QuantityPortfolioRowDeleted" msprop:Generator_TableClassName="QuantityPortfolioDataTable" msprop:Generator_RowChangedName="QuantityPortfolioRowChanged" msprop:Generator_RowClassName="QuantityPortfolioRow" msprop:Generator_RowChangingName="QuantityPortfolioRowChanging" msprop:Generator_RowEvArgName="QuantityPortfolioRowChangeEvent" msprop:Generator_RowEvHandlerName="QuantityPortfolioRowChangeEventHandler" msprop:Generator_TablePropName="QuantityPortfolio" msprop:Generator_TableVarName="tableQuantityPortfolio" msprop:Generator_RowDeletingName="QuantityPortfolioRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="QuantityTransaction" msprop:Generator_UserTableName="QuantityTransaction" msprop:Generator_RowDeletedName="QuantityTransactionRowDeleted" msprop:Generator_TableClassName="QuantityTransactionDataTable" msprop:Generator_RowChangedName="QuantityTransactionRowChanged" msprop:Generator_RowClassName="QuantityTransactionRow" msprop:Generator_RowChangingName="QuantityTransactionRowChanging" msprop:Generator_RowEvArgName="QuantityTransactionRowChangeEvent" msprop:Generator_RowEvHandlerName="QuantityTransactionRowChangeEventHandler" msprop:Generator_TablePropName="QuantityTransaction" msprop:Generator_TableVarName="tableQuantityTransaction" msprop:Generator_RowDeletingName="QuantityTransactionRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="QuantityPortfolioID" msprop:Generator_UserColumnName="QuantityPortfolioID" msprop:Generator_ColumnPropNameInRow="QuantityPortfolioID" msprop:Generator_ColumnVarNameInTable="columnQuantityPortfolioID" msprop:Generator_ColumnPropNameInTable="QuantityPortfolioIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PaperID" msprop:Generator_UserColumnName="PaperID" msprop:Generator_ColumnPropNameInRow="PaperID" msprop:Generator_ColumnVarNameInTable="columnPaperID" msprop:Generator_ColumnPropNameInTable="PaperIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionID" msprop:Generator_UserColumnName="ActionID" msprop:Generator_ColumnPropNameInRow="ActionID" msprop:Generator_ColumnVarNameInTable="columnActionID" msprop:Generator_ColumnPropNameInTable="ActionIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValueDate" msprop:Generator_UserColumnName="ValueDate" msprop:Generator_ColumnPropNameInRow="ValueDate" msprop:Generator_ColumnVarNameInTable="columnValueDate" msprop:Generator_ColumnPropNameInTable="ValueDateColumn" type="xs:dateTime" />
              <xs:element name="Quantity" msprop:Generator_UserColumnName="Quantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Source" msprop:Generator_UserTableName="Source" msprop:Generator_RowDeletedName="SourceRowDeleted" msprop:Generator_TableClassName="SourceDataTable" msprop:Generator_RowChangedName="SourceRowChanged" msprop:Generator_RowClassName="SourceRow" msprop:Generator_RowChangingName="SourceRowChanging" msprop:Generator_RowEvArgName="SourceRowChangeEvent" msprop:Generator_RowEvHandlerName="SourceRowChangeEventHandler" msprop:Generator_TablePropName="Source" msprop:Generator_TableVarName="tableSource" msprop:Generator_RowDeletingName="SourceRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Location" msprop:Generator_UserColumnName="Location" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInTable="LocationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="StockExchange" msprop:Generator_UserTableName="StockExchange" msprop:Generator_RowDeletedName="StockExchangeRowDeleted" msprop:Generator_TableClassName="StockExchangeDataTable" msprop:Generator_RowChangedName="StockExchangeRowChanged" msprop:Generator_RowClassName="StockExchangeRow" msprop:Generator_RowChangingName="StockExchangeRowChanging" msprop:Generator_RowEvArgName="StockExchangeRowChangeEvent" msprop:Generator_RowEvHandlerName="StockExchangeRowChangeEventHandler" msprop:Generator_TablePropName="StockExchange" msprop:Generator_TableVarName="tableStockExchange" msprop:Generator_RowDeletingName="StockExchangeRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="StocksQuote" msprop:Generator_UserTableName="StocksQuote" msprop:Generator_RowDeletedName="StocksQuoteRowDeleted" msprop:Generator_TableClassName="StocksQuoteDataTable" msprop:Generator_RowChangedName="StocksQuoteRowChanged" msprop:Generator_RowClassName="StocksQuoteRow" msprop:Generator_RowChangingName="StocksQuoteRowChanging" msprop:Generator_RowEvArgName="StocksQuoteRowChangeEvent" msprop:Generator_RowEvHandlerName="StocksQuoteRowChangeEventHandler" msprop:Generator_TablePropName="StocksQuote" msprop:Generator_TableVarName="tableStocksQuote" msprop:Generator_RowDeletingName="StocksQuoteRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PaperID" msprop:Generator_UserColumnName="PaperID" msprop:Generator_ColumnPropNameInRow="PaperID" msprop:Generator_ColumnVarNameInTable="columnPaperID" msprop:Generator_ColumnPropNameInTable="PaperIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" type="xs:dateTime" />
              <xs:element name="ClosingRate" msprop:Generator_UserColumnName="ClosingRate" msprop:Generator_ColumnPropNameInRow="ClosingRate" msprop:Generator_ColumnVarNameInTable="columnClosingRate" msprop:Generator_ColumnPropNameInTable="ClosingRateColumn" type="xs:decimal" />
              <xs:element name="PackageID" msprop:Generator_UserColumnName="PackageID" msprop:Generator_ColumnPropNameInRow="PackageID" msprop:Generator_ColumnVarNameInTable="columnPackageID" msprop:Generator_ColumnPropNameInTable="PackageIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionID" msprop:Generator_UserColumnName="TransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Action" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Tax_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tax" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="CashAction_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CashAction" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="CashPortfolio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CashPortfolio" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="CashTransaction_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CashTransaction" />
      <xs:field xpath="mstns:TransactionID" />
    </xs:unique>
    <xs:unique name="Commission_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Commission" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Country_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Country" />
      <xs:field xpath="mstns:Code" />
    </xs:unique>
    <xs:unique name="Currency_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Currency" />
      <xs:field xpath="mstns:Code" />
    </xs:unique>
    <xs:unique name="DividendsQuote_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DividendsQuote" />
      <xs:field xpath="mstns:PaperID" />
      <xs:field xpath="mstns:ExDate" />
      <xs:field xpath="mstns:PackageID" />
    </xs:unique>
    <xs:unique name="ExchangeRatesQuote_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ExchangeRatesQuote" />
      <xs:field xpath="mstns:SourceCurrencyCode" />
      <xs:field xpath="mstns:TargetCurrencyCode" />
      <xs:field xpath="mstns:Date" />
      <xs:field xpath="mstns:PackageID" />
    </xs:unique>
    <xs:unique name="InvestmentHouse_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:InvestmentHouse" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Manager_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Manager" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Package_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Package" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Paper_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Paper" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Portfolio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Portfolio" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="PortfolioType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PortfolioType" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="QuantityPortfolio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:QuantityPortfolio" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="QuantityTransaction_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:QuantityTransaction" />
      <xs:field xpath="mstns:TransactionID" />
    </xs:unique>
    <xs:unique name="Source_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Source" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="StockExchange_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StockExchange" />
      <xs:field xpath="mstns:Code" />
    </xs:unique>
    <xs:unique name="StocksQuote_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StocksQuote" />
      <xs:field xpath="mstns:PaperID" />
      <xs:field xpath="mstns:Date" />
      <xs:field xpath="mstns:PackageID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Tax_Action" msdata:parent="Action" msdata:child="Tax" msdata:parentkey="ID" msdata:childkey="ActionId" msprop:Generator_UserRelationName="FK_Tax_Action" msprop:Generator_RelationVarName="relationFK_Tax_Action" msprop:Generator_UserChildTable="Tax" msprop:Generator_UserParentTable="Action" msprop:Generator_ParentPropName="ActionRow" msprop:Generator_ChildPropName="GetTaxRows" />
      <msdata:Relationship name="FK_Tax_Country" msdata:parent="Country" msdata:child="Tax" msdata:parentkey="Code" msdata:childkey="CountryCode" msprop:Generator_UserRelationName="FK_Tax_Country" msprop:Generator_RelationVarName="relationFK_Tax_Country" msprop:Generator_UserChildTable="Tax" msprop:Generator_UserParentTable="Country" msprop:Generator_ParentPropName="CountryRow" msprop:Generator_ChildPropName="GetTaxRows" />
      <msdata:Relationship name="FK_Tax_Package" msdata:parent="Package" msdata:child="Tax" msdata:parentkey="ID" msdata:childkey="PackageID" msprop:Generator_UserRelationName="FK_Tax_Package" msprop:Generator_RelationVarName="relationFK_Tax_Package" msprop:Generator_UserChildTable="Tax" msprop:Generator_UserParentTable="Package" msprop:Generator_ParentPropName="PackageRow" msprop:Generator_ChildPropName="GetTaxRows" />
      <msdata:Relationship name="FK_CashTransaction_CashAction" msdata:parent="CashAction" msdata:child="CashTransaction" msdata:parentkey="ID" msdata:childkey="ActionID" msprop:Generator_UserRelationName="FK_CashTransaction_CashAction" msprop:Generator_RelationVarName="relationFK_CashTransaction_CashAction" msprop:Generator_UserChildTable="CashTransaction" msprop:Generator_UserParentTable="CashAction" msprop:Generator_ParentPropName="CashActionRow" msprop:Generator_ChildPropName="GetCashTransactionRows" />
      <msdata:Relationship name="FK_CashTransaction_CashPortfolio" msdata:parent="CashPortfolio" msdata:child="CashTransaction" msdata:parentkey="ID" msdata:childkey="CashPotfolioID" msprop:Generator_UserRelationName="FK_CashTransaction_CashPortfolio" msprop:Generator_RelationVarName="relationFK_CashTransaction_CashPortfolio" msprop:Generator_UserChildTable="CashTransaction" msprop:Generator_UserParentTable="CashPortfolio" msprop:Generator_ParentPropName="CashPortfolioRow" msprop:Generator_ChildPropName="GetCashTransactionRows" />
      <msdata:Relationship name="FK_CashTransaction_Currency" msdata:parent="Currency" msdata:child="CashTransaction" msdata:parentkey="Code" msdata:childkey="CurrencyCode" msprop:Generator_UserRelationName="FK_CashTransaction_Currency" msprop:Generator_RelationVarName="relationFK_CashTransaction_Currency" msprop:Generator_UserChildTable="CashTransaction" msprop:Generator_UserParentTable="Currency" msprop:Generator_ParentPropName="CurrencyRow" msprop:Generator_ChildPropName="GetCashTransactionRows" />
      <msdata:Relationship name="FK_Commission_Action" msdata:parent="Action" msdata:child="Commission" msdata:parentkey="ID" msdata:childkey="ActionID" msprop:Generator_UserRelationName="FK_Commission_Action" msprop:Generator_RelationVarName="relationFK_Commission_Action" msprop:Generator_UserChildTable="Commission" msprop:Generator_UserParentTable="Action" msprop:Generator_ParentPropName="ActionRow" msprop:Generator_ChildPropName="GetCommissionRows" />
      <msdata:Relationship name="FK_Commission_Currency" msdata:parent="Currency" msdata:child="Commission" msdata:parentkey="Code" msdata:childkey="CurrencyCode" msprop:Generator_UserRelationName="FK_Commission_Currency" msprop:Generator_RelationVarName="relationFK_Commission_Currency" msprop:Generator_UserChildTable="Commission" msprop:Generator_UserParentTable="Currency" msprop:Generator_ParentPropName="CurrencyRow" msprop:Generator_ChildPropName="GetCommissionRows" />
      <msdata:Relationship name="FK_Commission_InvestmentHouse" msdata:parent="InvestmentHouse" msdata:child="Commission" msdata:parentkey="ID" msdata:childkey="InvestmentHouseID" msprop:Generator_UserRelationName="FK_Commission_InvestmentHouse" msprop:Generator_RelationVarName="relationFK_Commission_InvestmentHouse" msprop:Generator_UserChildTable="Commission" msprop:Generator_UserParentTable="InvestmentHouse" msprop:Generator_ParentPropName="InvestmentHouseRow" msprop:Generator_ChildPropName="GetCommissionRows" />
      <msdata:Relationship name="FK_Commission_Source" msdata:parent="Source" msdata:child="Commission" msdata:parentkey="ID" msdata:childkey="SourceID" msprop:Generator_UserRelationName="FK_Commission_Source" msprop:Generator_RelationVarName="relationFK_Commission_Source" msprop:Generator_UserChildTable="Commission" msprop:Generator_UserParentTable="Source" msprop:Generator_ParentPropName="SourceRow" msprop:Generator_ChildPropName="GetCommissionRows" />
      <msdata:Relationship name="FK_Country_Currency" msdata:parent="Currency" msdata:child="Country" msdata:parentkey="Code" msdata:childkey="CurrencyCode" msprop:Generator_UserRelationName="FK_Country_Currency" msprop:Generator_RelationVarName="relationFK_Country_Currency" msprop:Generator_UserChildTable="Country" msprop:Generator_UserParentTable="Currency" msprop:Generator_ParentPropName="CurrencyRow" msprop:Generator_ChildPropName="GetCountryRows" />
      <msdata:Relationship name="FK_DividendsQuote_Package" msdata:parent="Package" msdata:child="DividendsQuote" msdata:parentkey="ID" msdata:childkey="PackageID" msprop:Generator_UserRelationName="FK_DividendsQuote_Package" msprop:Generator_RelationVarName="relationFK_DividendsQuote_Package" msprop:Generator_UserChildTable="DividendsQuote" msprop:Generator_UserParentTable="Package" msprop:Generator_ParentPropName="PackageRow" msprop:Generator_ChildPropName="GetDividendsQuoteRows" />
      <msdata:Relationship name="FK_DividendsQuote_Paper" msdata:parent="Paper" msdata:child="DividendsQuote" msdata:parentkey="ID" msdata:childkey="PaperID" msprop:Generator_UserRelationName="FK_DividendsQuote_Paper" msprop:Generator_RelationVarName="relationFK_DividendsQuote_Paper" msprop:Generator_UserChildTable="DividendsQuote" msprop:Generator_UserParentTable="Paper" msprop:Generator_ParentPropName="PaperRow" msprop:Generator_ChildPropName="GetDividendsQuoteRows" />
      <msdata:Relationship name="FK_ExchangeRatesQuote_Currency" msdata:parent="Currency" msdata:child="ExchangeRatesQuote" msdata:parentkey="Code" msdata:childkey="SourceCurrencyCode" msprop:Generator_UserRelationName="FK_ExchangeRatesQuote_Currency" msprop:Generator_RelationVarName="relationFK_ExchangeRatesQuote_Currency" msprop:Generator_UserChildTable="ExchangeRatesQuote" msprop:Generator_UserParentTable="Currency" msprop:Generator_ParentPropName="CurrencyRowByFK_ExchangeRatesQuote_Currency" msprop:Generator_ChildPropName="GetExchangeRatesQuoteRowsByFK_ExchangeRatesQuote_Currency" />
      <msdata:Relationship name="FK_ExchangeRatesQuote_Currency1" msdata:parent="Currency" msdata:child="ExchangeRatesQuote" msdata:parentkey="Code" msdata:childkey="TargetCurrencyCode" msprop:Generator_UserRelationName="FK_ExchangeRatesQuote_Currency1" msprop:Generator_RelationVarName="relationFK_ExchangeRatesQuote_Currency1" msprop:Generator_UserChildTable="ExchangeRatesQuote" msprop:Generator_UserParentTable="Currency" msprop:Generator_ParentPropName="CurrencyRowByFK_ExchangeRatesQuote_Currency1" msprop:Generator_ChildPropName="GetExchangeRatesQuoteRowsByFK_ExchangeRatesQuote_Currency1" />
      <msdata:Relationship name="FK_ExchangeRatesQuote_Package" msdata:parent="Package" msdata:child="ExchangeRatesQuote" msdata:parentkey="ID" msdata:childkey="PackageID" msprop:Generator_UserRelationName="FK_ExchangeRatesQuote_Package" msprop:Generator_RelationVarName="relationFK_ExchangeRatesQuote_Package" msprop:Generator_UserChildTable="ExchangeRatesQuote" msprop:Generator_UserParentTable="Package" msprop:Generator_ParentPropName="PackageRow" msprop:Generator_ChildPropName="GetExchangeRatesQuoteRows" />
      <msdata:Relationship name="FK_Package_Source" msdata:parent="Source" msdata:child="Package" msdata:parentkey="ID" msdata:childkey="SourceID" msprop:Generator_UserRelationName="FK_Package_Source" msprop:Generator_RelationVarName="relationFK_Package_Source" msprop:Generator_UserChildTable="Package" msprop:Generator_UserParentTable="Source" msprop:Generator_ParentPropName="SourceRow" msprop:Generator_ChildPropName="GetPackageRows" />
      <msdata:Relationship name="FK_Paper_StockExchange" msdata:parent="StockExchange" msdata:child="Paper" msdata:parentkey="Code" msdata:childkey="StockExchangeCode" msprop:Generator_UserRelationName="FK_Paper_StockExchange" msprop:Generator_RelationVarName="relationFK_Paper_StockExchange" msprop:Generator_UserChildTable="Paper" msprop:Generator_UserParentTable="StockExchange" msprop:Generator_ParentPropName="StockExchangeRow" msprop:Generator_ChildPropName="GetPaperRows" />
      <msdata:Relationship name="FK_Portfolio_CashPortfolio" msdata:parent="CashPortfolio" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="CashPortfolioID" msprop:Generator_UserRelationName="FK_Portfolio_CashPortfolio" msprop:Generator_RelationVarName="relationFK_Portfolio_CashPortfolio" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="CashPortfolio" msprop:Generator_ParentPropName="CashPortfolioRow" msprop:Generator_ChildPropName="GetPortfolioRows" />
      <msdata:Relationship name="FK_Portfolio_Currency" msdata:parent="Currency" msdata:child="Portfolio" msdata:parentkey="Code" msdata:childkey="CurrencyCode" msprop:Generator_UserRelationName="FK_Portfolio_Currency" msprop:Generator_RelationVarName="relationFK_Portfolio_Currency" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="Currency" msprop:Generator_ParentPropName="CurrencyRow" msprop:Generator_ChildPropName="GetPortfolioRows" />
      <msdata:Relationship name="FK_Portfolio_InvestmentHouse" msdata:parent="InvestmentHouse" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="InvestmentHouseID" msprop:Generator_UserRelationName="FK_Portfolio_InvestmentHouse" msprop:Generator_RelationVarName="relationFK_Portfolio_InvestmentHouse" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="InvestmentHouse" msprop:Generator_ParentPropName="InvestmentHouseRow" msprop:Generator_ChildPropName="GetPortfolioRows" />
      <msdata:Relationship name="FK_Portfolio_Manager" msdata:parent="Manager" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="ManagerId" msprop:Generator_UserRelationName="FK_Portfolio_Manager" msprop:Generator_RelationVarName="relationFK_Portfolio_Manager" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="Manager" msprop:Generator_ParentPropName="ManagerRow" msprop:Generator_ChildPropName="GetPortfolioRows" />
      <msdata:Relationship name="FK_Portfolio_PortfolioType" msdata:parent="PortfolioType" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="TypeID" msprop:Generator_UserRelationName="FK_Portfolio_PortfolioType" msprop:Generator_RelationVarName="relationFK_Portfolio_PortfolioType" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="PortfolioType" msprop:Generator_ParentPropName="PortfolioTypeRow" msprop:Generator_ChildPropName="GetPortfolioRows" />
      <msdata:Relationship name="FK_Portfolio_QuantityPortfolio" msdata:parent="QuantityPortfolio" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="QuantityPortfolioID" msprop:Generator_UserRelationName="FK_Portfolio_QuantityPortfolio" msprop:Generator_RelationVarName="relationFK_Portfolio_QuantityPortfolio" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="QuantityPortfolio" msprop:Generator_ParentPropName="QuantityPortfolioRow" msprop:Generator_ChildPropName="GetPortfolioRows" />
      <msdata:Relationship name="FK_Portfolio_Source" msdata:parent="Source" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="TaxesSourceID" msprop:Generator_UserRelationName="FK_Portfolio_Source" msprop:Generator_RelationVarName="relationFK_Portfolio_Source" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="Source" msprop:Generator_ParentPropName="SourceRowByFK_Portfolio_Source" msprop:Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source" />
      <msdata:Relationship name="FK_Portfolio_Source1" msdata:parent="Source" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="CommissionsSourceID" msprop:Generator_UserRelationName="FK_Portfolio_Source1" msprop:Generator_RelationVarName="relationFK_Portfolio_Source1" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="Source" msprop:Generator_ParentPropName="SourceRowByFK_Portfolio_Source1" msprop:Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source1" />
      <msdata:Relationship name="FK_Portfolio_Source2" msdata:parent="Source" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="StocksQuotesSourceID" msprop:Generator_UserRelationName="FK_Portfolio_Source2" msprop:Generator_RelationVarName="relationFK_Portfolio_Source2" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="Source" msprop:Generator_ParentPropName="SourceRowByFK_Portfolio_Source2" msprop:Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source2" />
      <msdata:Relationship name="FK_Portfolio_Source3" msdata:parent="Source" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="DividendQuotesSourceID" msprop:Generator_UserRelationName="FK_Portfolio_Source3" msprop:Generator_RelationVarName="relationFK_Portfolio_Source3" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="Source" msprop:Generator_ParentPropName="SourceRowByFK_Portfolio_Source3" msprop:Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source3" />
      <msdata:Relationship name="FK_Portfolio_Source4" msdata:parent="Source" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="ExchangeRatesQuotesSourceID" msprop:Generator_UserRelationName="FK_Portfolio_Source4" msprop:Generator_RelationVarName="relationFK_Portfolio_Source4" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="Source" msprop:Generator_ParentPropName="SourceRowByFK_Portfolio_Source4" msprop:Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source4" />
      <msdata:Relationship name="FK_Portfolio_Source5" msdata:parent="Source" msdata:child="Portfolio" msdata:parentkey="ID" msdata:childkey="NotStocksQuotesSourceID" msprop:Generator_UserRelationName="FK_Portfolio_Source5" msprop:Generator_RelationVarName="relationFK_Portfolio_Source5" msprop:Generator_UserChildTable="Portfolio" msprop:Generator_UserParentTable="Source" msprop:Generator_ParentPropName="SourceRowByFK_Portfolio_Source5" msprop:Generator_ChildPropName="GetPortfolioRowsByFK_Portfolio_Source5" />
      <msdata:Relationship name="FK_QuantityTransaction_Action" msdata:parent="Action" msdata:child="QuantityTransaction" msdata:parentkey="ID" msdata:childkey="ActionID" msprop:Generator_UserRelationName="FK_QuantityTransaction_Action" msprop:Generator_RelationVarName="relationFK_QuantityTransaction_Action" msprop:Generator_UserChildTable="QuantityTransaction" msprop:Generator_UserParentTable="Action" msprop:Generator_ParentPropName="ActionRow" msprop:Generator_ChildPropName="GetQuantityTransactionRows" />
      <msdata:Relationship name="FK_QuantityTransaction_Package" msdata:parent="Package" msdata:child="QuantityTransaction" msdata:parentkey="ID" msdata:childkey="PackageID" msprop:Generator_UserRelationName="FK_QuantityTransaction_Package" msprop:Generator_RelationVarName="relationFK_QuantityTransaction_Package" msprop:Generator_UserChildTable="QuantityTransaction" msprop:Generator_UserParentTable="Package" msprop:Generator_ParentPropName="PackageRow" msprop:Generator_ChildPropName="GetQuantityTransactionRows" />
      <msdata:Relationship name="FK_QuantityTransaction_Paper" msdata:parent="Paper" msdata:child="QuantityTransaction" msdata:parentkey="ID" msdata:childkey="PaperID" msprop:Generator_UserRelationName="FK_QuantityTransaction_Paper" msprop:Generator_RelationVarName="relationFK_QuantityTransaction_Paper" msprop:Generator_UserChildTable="QuantityTransaction" msprop:Generator_UserParentTable="Paper" msprop:Generator_ParentPropName="PaperRow" msprop:Generator_ChildPropName="GetQuantityTransactionRows" />
      <msdata:Relationship name="FK_QuantityTransaction_QuantityPortfolio" msdata:parent="QuantityPortfolio" msdata:child="QuantityTransaction" msdata:parentkey="ID" msdata:childkey="QuantityPortfolioID" msprop:Generator_UserRelationName="FK_QuantityTransaction_QuantityPortfolio" msprop:Generator_RelationVarName="relationFK_QuantityTransaction_QuantityPortfolio" msprop:Generator_UserChildTable="QuantityTransaction" msprop:Generator_UserParentTable="QuantityPortfolio" msprop:Generator_ParentPropName="QuantityPortfolioRow" msprop:Generator_ChildPropName="GetQuantityTransactionRows" />
      <msdata:Relationship name="FK_StockExchange_Country" msdata:parent="Country" msdata:child="StockExchange" msdata:parentkey="Code" msdata:childkey="CountryCode" msprop:Generator_UserRelationName="FK_StockExchange_Country" msprop:Generator_RelationVarName="relationFK_StockExchange_Country" msprop:Generator_UserChildTable="StockExchange" msprop:Generator_UserParentTable="Country" msprop:Generator_ParentPropName="CountryRow" msprop:Generator_ChildPropName="GetStockExchangeRows" />
      <msdata:Relationship name="FK_StocksQuote_Package" msdata:parent="Package" msdata:child="StocksQuote" msdata:parentkey="ID" msdata:childkey="PackageID" msprop:Generator_UserRelationName="FK_StocksQuote_Package" msprop:Generator_RelationVarName="relationFK_StocksQuote_Package" msprop:Generator_UserChildTable="StocksQuote" msprop:Generator_UserParentTable="Package" msprop:Generator_ParentPropName="PackageRow" msprop:Generator_ChildPropName="GetStocksQuoteRows" />
      <msdata:Relationship name="FK_StocksQuote_Paper" msdata:parent="Paper" msdata:child="StocksQuote" msdata:parentkey="ID" msdata:childkey="PaperID" msprop:Generator_UserRelationName="FK_StocksQuote_Paper" msprop:Generator_RelationVarName="relationFK_StocksQuote_Paper" msprop:Generator_UserChildTable="StocksQuote" msprop:Generator_UserParentTable="Paper" msprop:Generator_ParentPropName="PaperRow" msprop:Generator_ChildPropName="GetStocksQuoteRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>